import pandas as pd
data = [[110,120,105],[95,110,108],[98,80,100],[112,106,97]]
index = ['王蒙', '李珊', '赵胜', '刘文']
columns = ['语文','数学','英语']
df = pd.DataFrame(data, index, columns)
print('保存到“score1”工作表中的数据： \n', df)
writer=pd.ExcelWriter('Score.xlsx')
df.to_excel(writer,sheet_name='score1')
df.iloc[0]=[105,118,100]
print('保存到“score2”工作表中的数据： \n', df)
df.to_excel(writer,sheet_name='score2')
writer._save()
df1=pd.read_excel('Score.xlsx', sheet_name=['score1','score2'],index_col=0)
print('导入的数据:\n',df1)